// Copyright (c) Appeon. All rights reserved.
// Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. 
// You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0.

namespace SnapObjects.Data
{
    /// <summary>
    ///     Represents an object used to build a SQL DELETE statement. 
    ///     The SQL DELETE statement can be used to remove one or more rows from the database.
    /// </summary>
    public interface ISqlDeleteBuilder : ISqlFromBuilder, ISqlBuilder
    {
        /// <summary>
        ///     Creates a SQL DELETE statement and specifies the name of the table or view from which the rows are to be removed.
        /// </summary>
        /// <param name="table">The name of the table or view from which the rows are to be removed.</param>
        /// <returns>Returns the current ISqlDeleteBuilder object.</returns>
        ISqlDeleteBuilder Delete(string table);

        /// <summary>
        ///     Creates a SQL DELETE statement and specifies the name and the schema of the table or view from which 
        ///     the rows are to be removed.
        /// </summary>
        /// <param name="table">The name of the table or view from which the rows are to be removed.</param>
        /// <param name="schema">The schema of the table or view from which the rows are to be removed.</param>
        /// <returns>Returns the current ISqlDeleteBuilder object.</returns>
        ISqlDeleteBuilder Delete(string table, string schema);
    }
}
